[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '20' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55 | 12.45 | 1997-02-16 | Production | david2@adventure-works.com | David Ortiz | 712-555-0119 | 36151748 | David | M | 2021-02-02 | Ortiz | adventure-works\david2 | M | J | 20 | 1 | 712-555-0119 | | 36 | 2021-02-02 | Current | Production Technician - WC60 | 33 |
| 178 | 12.45 | 2003-05-25 | Production | steve0@adventure-works.com | Steve Masters | 712-555-0170 | 752513276 | Steve | M | 2021-04-05 | Masters | adventure-works\steve0 | S | F | 20 | 1 | 712-555-0170 | | 35 | 2021-04-05 | Current | Production Technician - WC60 | 31 |
| 212 | 12.45 | 1988-03-31 | Production | jay0@adventure-works.com | Jay Adams | 407-555-0165 | 63179277 | Jay | M | 2021-04-23 | Adams | adventure-works\jay0 | S | G | 20 | 1 | 407-555-0165 | | 36 | 2021-04-23 | Current | Production Technician - WC60 | 32 |
| 223 | 12.45 | 1983-10-21 | Production | charles0@adventure-works.com | Charles Fitzgerald | 931-555-0118 | 537092325 | Charles | M | 2022-01-21 | Fitzgerald | adventure-works\charles0 | S | B | 20 | 1 | 931-555-0118 | | 33 | 2022-01-21 | Current | Production Technician - WC60 | 27 |
| 230 | 12.45 | 1982-04-25 | Production | karan0@adventure-works.com | Karan Khanna | 447-555-0186 | 834186596 | Karan | M | 2022-02-09 | Khanna | adventure-works\karan0 | S | R | 20 | 1 | 447-555-0186 | | 34 | 2022-02-09 | Current | Production Technician - WC60 | 28 |
| 247 | 12.45 | 1967-03-20 | Production | maciej0@adventure-works.com | Maciej Dusza | 237-555-0128 | 414476027 | Maciej | M | 2022-03-19 | Dusza | adventure-works\maciej0 | S | W | 20 | 1 | 237-555-0128 | | 35 | 2022-03-19 | Current | Production Technician - WC60 | 30 |
| 258 | 12.45 | 1985-10-24 | Production | michael7@adventure-works.com | Michael Zwilling | 582-555-0148 | 582347317 | Michael | M | 2022-04-13 | Zwilling | adventure-works\michael7 | S | J | 20 | 1 | 582-555-0148 | | 33 | 2022-04-13 | Current | Production Technician - WC60 | 26 |
| 259 | 12.45 | 1982-06-16 | Production | randy0@adventure-works.com | Randy Reeves | 961-555-0122 | 8066363 | Randy | M | 2022-04-13 | Reeves | adventure-works\randy0 | M | T | 20 | 1 | 961-555-0122 | | 34 | 2022-04-13 | Current | Production Technician - WC60 | 29 |
Generated 2026-08-18 15:43:57.458 UTC